UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IAfGg928KNCfWJORDYWSHHPwf6iOi9je1F+ofqNk+sg='
WHERE
key_id = 'e1bf3d3e9d161450de23e418834b159e0778f18445cd5971ad0c68361806c106'
AND (
token = 'IAfGg928KNCfWJORDYWSHHPwf6iOi9je1F+ofqNk+sg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)