UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w6QMX26sGZKoTcGhRS0fVXlmho1bVHxZHq3dxfuMVLk='
WHERE
key_id = '831220e26e3c55f552e863f3613d4ed5f29f64913991152194713a9c695a95ac'
AND (
token = 'w6QMX26sGZKoTcGhRS0fVXlmho1bVHxZHq3dxfuMVLk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)