UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Bz9giXFBazY5Sq2D1wxjXwN+CHCldmP7bAf15I8Qi0='
WHERE
key_id = '3a1f6b55399a059d2be34ee657c00a9355dd6d218e39ca122f220509442b11d3'
AND (
token = '8Bz9giXFBazY5Sq2D1wxjXwN+CHCldmP7bAf15I8Qi0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)