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