UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yj6BateSMQQEfXj/ciskrcoNL6bvSrEkS6vsTdUisTk='
WHERE
key_id = 'a6ec75d69d7118520b7d8230a781d1a2431785620399652b19110bf37227a385'
AND (
token = 'Yj6BateSMQQEfXj/ciskrcoNL6bvSrEkS6vsTdUisTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)