UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+PCTVrkZ7cLORlD5Xf3kFj/uHQWgmCUoV72tWu1SSM4='
WHERE
key_id = '212d49996e720b48e805ada2151bf919609b20447cd7eaf0b94ee02b4ec328d4'
AND (
token = '+PCTVrkZ7cLORlD5Xf3kFj/uHQWgmCUoV72tWu1SSM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)