UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KXmi7kId76V5xgiLyGs97gDZED+Fr63QPaMZXGWLzDI='
WHERE
key_id = '55e5d5b6bcd0b10c35a70330f34be3998b15145196c9b41a1d011d59df042f35'
AND (
token = 'KXmi7kId76V5xgiLyGs97gDZED+Fr63QPaMZXGWLzDI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)