UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'piRdIqrRVsd9gX2f7t9b6CTCIyJfS0X0iMWM8USgklw='
WHERE
key_id = '3750dec7e23a0841549ed70a7c239fa96200e0ff319615851a8363dfc81a5cba'
AND (
token = 'piRdIqrRVsd9gX2f7t9b6CTCIyJfS0X0iMWM8USgklw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)