UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6mIxPvzjTuhQUEreI1KdeLEgiZ3uOw3N2jCKXGsawRY='
WHERE
key_id = '28c16dbcb681d11780f53859aecbf40397b1cc1a0aaa59a0e7676870814e0001'
AND (
token = '6mIxPvzjTuhQUEreI1KdeLEgiZ3uOw3N2jCKXGsawRY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)