UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AnDKKHtqhUBFdq3g2U1UOkn/3hoDYvwl+THBX5jehZ4='
WHERE
key_id = 'e0fce7c1d9599d478e82f687fb431ddde046f143f3d6659f15788a398dcbe59b'
AND (
token = 'AnDKKHtqhUBFdq3g2U1UOkn/3hoDYvwl+THBX5jehZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)