UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Tlc2x/s0NrhQwg2UxkrK12FeGr3Lx0jc30kjBye1q8='
WHERE
key_id = 'aee3e685a7629bacafd4bdd69cae8f2b72166dbe35acc97b3bd6ec1a8b965307'
AND (
token = '3Tlc2x/s0NrhQwg2UxkrK12FeGr3Lx0jc30kjBye1q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)