UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6jvVZxZbGAyjUVpqJairLcYCB/nBGNJkGxKFpn/gwtI='
WHERE
key_id = '4d0fe8c148b178a9fd735b8296afd396236b84bc28934bbe3754f1b3381a8317'
AND (
token = '6jvVZxZbGAyjUVpqJairLcYCB/nBGNJkGxKFpn/gwtI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)