UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oWuYwku3emciJgeFVSbQPajHWZmf4pv4u1aL8O7gR8Q='
WHERE
key_id = '0ab4c69342b6dfcbefa6d319cc3cf43e0251ab66b8d275db941e4b712ce4172e'
AND (
token = 'oWuYwku3emciJgeFVSbQPajHWZmf4pv4u1aL8O7gR8Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)