UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UMVOFMDj5DxNj3D8iwhd9yu8vWbDxnSHqdEWu68f9b8='
WHERE
key_id = 'd9515d5d622e35993145581b69a6cc1afc3a99d715eb31d119f0c35ab6a441bf'
AND (
token = 'UMVOFMDj5DxNj3D8iwhd9yu8vWbDxnSHqdEWu68f9b8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)