UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P+9nTnQbA6jfpqz5iJG05Nl1S1TSI94f/FAFIsp9aWM='
WHERE
key_id = '017c7090aeb400c3a068487ff80e3fd964e2723eb801179482169967242a851b'
AND (
token = 'P+9nTnQbA6jfpqz5iJG05Nl1S1TSI94f/FAFIsp9aWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)