UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dcp4Dig8kSvSvvv5i9XORL4EJzv585hoq43zDZMOsvE='
WHERE
key_id = 'a8aca08806de64effb7385cccbe54522904363505c29dafc26998e69a0a841d7'
AND (
token = 'dcp4Dig8kSvSvvv5i9XORL4EJzv585hoq43zDZMOsvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)