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