UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'exYsBe/xK20Eiiz+fyewKTXuWFiVYX92h+OR8V5/bvU='
WHERE
key_id = '8cfd3363821f87febb5f9a005b6546ad2c3f0862850f444d7167f09250556367'
AND (
token = 'exYsBe/xK20Eiiz+fyewKTXuWFiVYX92h+OR8V5/bvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)