UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '31NBih0f+AEkVWHFt+vvO2P9REE5OSaZbidcqj68ylc='
WHERE
key_id = '1ea504d3e0e1fade56f18b583b56fccd276cc19dcba9630da32bd6c03355c2b0'
AND (
token = '31NBih0f+AEkVWHFt+vvO2P9REE5OSaZbidcqj68ylc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)