UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z0CfsFoN4BbqW9Ip7u1k7UvqEWMs1kDT5cAfprZbzrI='
WHERE
key_id = '78edf4c0ddb6bb116539a80e660651e3b870617d73f90d97b559c6f3a41ade6f'
AND (
token = 'Z0CfsFoN4BbqW9Ip7u1k7UvqEWMs1kDT5cAfprZbzrI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)