UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DC6YAXSu8jeEVmyXcbfI+W8Tozyx/clX19jGjIB3ooU='
WHERE
key_id = '020f5ec4ac7aa112df2b827c3c7284f5d588a1be6c1ff009d8e9d9ed25037007'
AND (
token = 'DC6YAXSu8jeEVmyXcbfI+W8Tozyx/clX19jGjIB3ooU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)