UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y5DCbx/0BLUxd0NDnUu90sK7OrpxDRRA3yjK5fB4Irg='
WHERE
key_id = '3de7f3adafb533593daad570c2f7e091204e17355049abb47ab3dbb9731e5dc2'
AND (
token = 'y5DCbx/0BLUxd0NDnUu90sK7OrpxDRRA3yjK5fB4Irg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)