UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+Nk1frgxFnsG7JdgKbrcWWkN+87edYzmnV8dxmaK65A='
WHERE
key_id = '0387982b6fdee7bb527f3b046c8f15969f4b715c889cb19f65298740bf975481'
AND (
token = '+Nk1frgxFnsG7JdgKbrcWWkN+87edYzmnV8dxmaK65A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)