UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bbXMhpNDDZhZ82HXcVqRcur39299MxGuv2u+T6pNfS8='
WHERE
key_id = '9a3d2b649a4e1bfd46fb5ef19e6cb82a2d4bfae6a3c6206b25d039cc488cdc1f'
AND (
token = 'bbXMhpNDDZhZ82HXcVqRcur39299MxGuv2u+T6pNfS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)